<html><head><title>SQL Database Administrator - San Francisco, CA 94105</title></head>
<body><h2>SQL Database Administrator - San Francisco, CA 94105</h2>
<h2 class="jobSectionHeader"><b>Summary
</b></h2><div><div><div><div>Esurance is looking for a SQL Database Administrator to join a dynamic and award-winning team of individuals who are committed to making insurance smarter, easier, and dare we say- cooler. As part of a growing company that is focused on providing an outstanding customer experience, you’ll have the opportunity to expand your skills and discover your potential.<br/>
<br/>
If you’re looking for a career at a socially conscious company that offers great benefits — including matching 401k and tuition reimbursement — then you may have just found your new home.<br/>
<br/>
Esurance combines the spunk of a startup company with the backing of Allstate (the largest publicly held personal lines insurer in the U.S.) to create a unique, energized, and exciting place to work.</div>
</div></div></div><h2 class="jobSectionHeader"><b>Responsibilities
</b></h2><div><div><div><div>The SQL Database Administrator will play an integral role in the implementation of SQL development, acceptance, and production environment, working closely with multiple infrastructure teams. Ongoing production support of existing databases is the primary role. The SQL DBA will provide administration support for various critical applications such as Microsoft SQL Server, MySQL and MongoDB.<br/>
<br/>
Job Responsibilities:<br/>
</div><ul><li>Monitors capacity and performance for production and non-production databases to ensure they are highly reliable, efficient, cost effective, and provide the required functionality</li><li>Seeks opportunities to improve database performance by identifying tuning measures and implementing them when appropriate</li><li>Tests upgrades/new releases of database software and related products. Assesses impacts to customers and the database environment</li><li>Plays major contributor role in the testing and evaluating of new database products and tools. This includes the determination of their applicability to the database environment</li><li>Provides database problem resolution support, including off-hours coverage, based on required business service levels</li><li>Actively participates in day-to-day interactions with various cross-functional teams of developers, DBAs and associate product managers</li><li>Analyzes designs, creates and implements databases, including access methods, device allocations, validation checks, organization and security</li><li>Designs data models, logical and physical databases, data dictionaries and schemas</li><li>Checking high availability and/or disaster recovery process logs which will depend on the solution (Log Shipping, Clustering, Replication, Database Mirroring, CDP, etc.) that is being used</li><li>Monitors log shipping and mirroring using the customized stored procedures</li><li>Verifying backups on a regular basis by randomly choosing one or two backups and trying to restore verify</li><li>Checking for service packs/patches that need to be installed on SQL Server from either a hardware, OS, DBMS or application perspective</li><li>Performing capacity planning to ensure there is sufficient storage for a specific period of time such as for 3, 6, 12 or 18 months</li><li>Reviewing the fragmentation for databases to determine if particular indexes must be rebuilt based on analysis from a backup SQL Server</li><li>Scheduling an official maintenance requiring health checks on all premium databases and servers</li></ul><div><br/>
Qualifications:<br/>
</div><ul><li>Hands on experience administering SQL Server 2008+, Mysql 5.0+, Mongodb 3.0+</li><li>Expert knowledge of SQL and NOSQL architecture and concepts</li><li>Experience optimizing database solutions for multi-terabyte databases</li><li>Good knowledge of database backup and recovery scenarios</li><li>Good knowledge of database tools and utilities for performance tuning and administration</li><li>Must have experience writing and optimizing T-SQL, MySQL and MongoDB query</li><li>Must have experience writing scripts using PowerShell and/or Python</li><li>Must have experience with SQL Server Clustering, Always On Availability Groups, Log Shipping and Replication</li><li>Able to effectively work independently and within a collaborative team oriented environment using sound judgment in decision-making</li><li>Excellent communication skills, both verbal and written, with excellent analytical and problem solving skills</li><li>Organized and detail-oriented, able to work well under deadlines in a changing environment and perform multiple tasks effectively and concurrently</li></ul><div><br/>
Experience / Education:<br/>
</div><ul><li>3 to 5 years as a SQL DBA for MS SQL Server, MySQL and MongoDB</li><li>Bachelor’s Degree in Computer Technology or equivalent experience</li><li>Experience with T-SQL, tables, views, constraints, triggers, functions, stored procedures</li><li>Experience in MongoDB and MySQL will be a plus</li></ul><div><br/>
Physical Demands and Work Environment:<br/>
Representative of those that must be met by an employee to successfully perform the essential functions of this job. Must be able to operate a PC and sit for extended periods of time. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.</div>
</div></div></div><h2 class="jobSectionHeader"><b>Benefits
</b></h2><div><div><div><div>At Esurance, being committed to our employees is not just something we say, it’s something we do. Our benefits package is designed to help our associates stay healthy, meet their long-term financial goals, and balance the demands of work and personal life. Esurance rewards hard work, dedication, and creativity with competitive salaries and a generous bonus system. We are committed to our employees and we are dedicated to creating a diverse, positive, innovative and team-oriented work environment.</div><div></div><br/>
<div>
Health &amp; wellness</div><ul><li>Medical, vision, and dental insurance</li><li>Life Insurance</li><li>Accidental death and dismemberment coverage</li><li>Wellness tools and coaching</li><li>Group critical illness coverage</li><li>Accident indemnity and hospital indemnity plans</li><li>Group legal</li><li>Student Loan Repayment Program</li><li>Identity Protection</li></ul><div></div><br/>
<div>
Savings</div><ul><li>401(k) plan with annual matching contribution</li><li>Choice Dollars</li><li>Referral bonuses</li><li>Performance-rewarding bonus system</li><li>Tuition assistance program (up to $5,250 per year)</li><li>Health savings and flexible spending accounts</li><li>Commuter benefits</li></ul><div></div><br/>
<div>
Family &amp; community</div><ul><li>Adoption assistance</li><li>Buckle Up Baby program</li><li>Pet insurance discount</li><li>Charitable gift matching</li><li>Give Time, Get Time volunteer program</li><li>Employee Assistance Program</li></ul><div></div><br/>
<div>
Time off</div><ul><li>Paid time off (holidays, vacation, personal days)</li><li>Short-term disability</li><li>Long-term disability (employee-paid option)</li></ul></div></div></div></body>
</html>